Blogs

Analyzing Local Excel Data via SAS Addin to MS Office

By Angela Hall on SAS Learning Post October 27, 2009 Topics | Advanced Analytics Data Visualization

With local data highlighted in Microsoft Excel, you can then "Copy to SAS Server" to run SAS analytical tasks. The menu bar ('SAS' -> 'Active Data' -> 'Copy to SAS Server') is also the image below:

SAS provides a knowledge base entry at: http://support.sas.com/kb/32/009.html to show how this can be done with a SAS query result - writing back to the same source data set.

In EITHER case, you need to have WRITE access to the file space & associated metadata library on the server.

Note: A google search on "site:sas.com "'Copy to SAS Server"" also provides additional information on hotfixes and functionality capable via this menu item.

About Author

Angela Hall
Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.